PreparedStatement stmt = con.prepareStatement("update emp set dept = ? where emp_id = 71164"); stmt.setString(1,""); // wrong!! stmt.setNull(1); stmt.executeUpdate();